2 -- patch-drop-comment-fields.sql
4 -- T166732. Drop old xx_comment fields, and defaults from xx_comment_id fields.
6 DECLARE @
sql nvarchar(max),
9 ALTER TABLE /*_*/archive
DROP CONSTRAINT DF_ar_comment
, COLUMN ar_comment
;
10 ALTER TABLE /*_*/archive
DROP CONSTRAINT DF_ar_comment_id
;
12 ALTER TABLE /*_*/ipblocks
DROP CONSTRAINT DF_ipb_reason
, COLUMN ipb_reason
;
13 ALTER TABLE /*_*/ipblocks
DROP CONSTRAINT DF_ipb_reason_id
;
15 ALTER TABLE /*_*/image
DROP CONSTRAINT DF_img_description
, COLUMN img_description
;
16 ALTER TABLE /*_*/image
DROP CONSTRAINT DF_img_description_id
;
18 ALTER TABLE /*_*/oldimage
DROP CONSTRAINT DF_oi_description
, COLUMN oi_description
;
19 ALTER TABLE /*_*/oldimage
DROP CONSTRAINT DF_oi_description_id
;
21 ALTER TABLE /*_*/filearchive
DROP CONSTRAINT DF_fa_deleted_reason
, COLUMN fa_deleted_reason
;
22 ALTER TABLE /*_*/filearchive
DROP CONSTRAINT DF_fa_deleted_reason_id
;
23 ALTER TABLE /*_*/filearchive
DROP CONSTRAINT DF_fa_description
, COLUMN fa_description
;
24 ALTER TABLE /*_*/filearchive
DROP CONSTRAINT DF_fa_description_id
;
26 SET @
sql = 'ALTER TABLE /*_*/recentchanges DROP CONSTRAINT ';
28 FROM sys.default_constraints df
30 ON c.object_id
= df.parent_object_id
31 AND c.column_id
= df.parent_column_id
33 df.parent_object_id
= OBJECT_ID('/*_*/recentchanges')
34 AND c.
name = 'rc_comment';
35 SET @
sql = @
sql + @
id;
36 EXEC sp_executesql @
sql;
37 ALTER TABLE /*_*/recentchanges
DROP COLUMN rc_comment
;
38 ALTER TABLE /*_*/recentchanges
DROP CONSTRAINT DF_rc_comment_id
;
40 SET @
sql = 'ALTER TABLE /*_*/logging DROP CONSTRAINT ';
42 FROM sys.default_constraints df
44 ON c.object_id
= df.parent_object_id
45 AND c.column_id
= df.parent_column_id
47 df.parent_object_id
= OBJECT_ID('/*_*/logging')
48 AND c.
name = 'log_comment';
49 SET @
sql = @
sql + @
id;
50 EXEC sp_executesql @
sql;
51 ALTER TABLE /*_*/logging
DROP COLUMN log_comment
;
52 ALTER TABLE /*_*/logging
DROP CONSTRAINT DF_log_comment_id
;
54 ALTER TABLE /*_*/protected_titles
DROP CONSTRAINT DF_pt_reason
, COLUMN pt_reason
;
55 ALTER TABLE /*_*/protected_titles
DROP CONSTRAINT DF_pt_reason_id
;